package com.five.community.mapper;


import com.five.community.bean.Mailbox;
import com.five.community.bean.vo.MailboxVo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
@Mapper
public interface MailboxMapper {
    //    查询所有报修表信息
    List<Mailbox> selectAll() throws Exception;
    //    根据id查询信息
    Mailbox selectById(long id) throws Exception;
    //    根据信件来源名字查询信息
    List<Mailbox> selectByName() throws Exception;
    //最终查询显示页面
    List<MailboxVo> selectAllF() throws Exception;
    //最终页面查询根据名字查询信息
    List<MailboxVo> selectByNameF(String name) throws Exception;
    //页面删除操作
    void delete(long id) throws Exception;
    //添加插入操作
    void insert(Mailbox mailbox) throws Exception;

    //修改信箱信息
    void update(Mailbox mailbox) throws Exception;
}
